Re: [SQL] DISTINCT count(*), possible? - Mailing list pgsql-sql

At 11:55 +0300 on 16/06/1999, Stuart Rison wrote:


> A previously posted work-around (search the GENERAL mailing list with
> 'count', 'DISTINCT' and 'Herouth') adapted to your query is:
>
> SELECT count(*)
> FROM aro t1
> WHERE int( oid ) = (
>     SELECT min( int( t2.oid ) )
>     FROM test t2
>     WHERE t2.address1 = t1.address1
> );

Since I apparently own the copyright for this solution :-)

The internal FROM should read "FROM aro t2", not "FROM test t2".

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma